|
| |
|
|
Database Version Management for Application Development in Eclipse
Palarczyk, Vít ; Šebek, Michal (referee) ; Burget, Radek (advisor)
This thesis deals with database version control for application development in Eclipse. In the theoretical part, it provides information about the Eclipse environment and its extension modules (plugins) that are an inseparable part of Eclipse. There is also a description of version control systems with a detailed focus on the Subversion system and a description of the JDBC application interface that is used for connecting the database in Java applications. The next part deals with the design of a tool for database version control, which is implemented as a plugin for Eclipse. In this section, there is a description of the implementation and a description of the installation and use of this tool. In the final part, there is a description of the performed tests and their results.
|
|
|
Database System Analysis and Implementation
Třetina, Jan ; Ráb, Jaroslav (referee) ; Zendulka, Jaroslav (advisor)
With the increase of demands for the speed and availability of the information technologies, the process of optimization gains more and more importance. Concerning search engine optimization, optimization of operating systems or application optimization (source code), the goal is to gain faster, smaller and more maintainable solution. In my thesis I deal with optimization of database systems, which includes low level of database tuning - physical organization of data and indices, database management system tuning and query optimization. I focused on optimization of Microsoft SQL Servers 2005 in enterprise environment.
|
|
|
Comparison of selected database systems
Fiala, Adam ; Chlapek, Dušan (advisor) ; Kučera, Jan (referee)
This bachelor thesis is based on comparison of popular open source and proprietary database systems. The criteria were preselected in advance and highlight the strengths and weaknesses of each defined system. In addition to that, this thesis is focused on the characteristics which are playing an important role and might be significant for database selection. First part of the work is dedicated to database problematic concepts and various software categories where each individual system belongs along with the associated types of licenses. This thesis is also providing an overview of market analysis that is followed by introduction of selected products. Second part of the work is mainly focused on criteria selection and actual comparison. As a conclusion, an overview summary of results are gathered which can serve as an important information for selecting the right database management system.
|
|
|
Comparison of database systems from the point of view of database administration
Andreyuk, Yauheniya ; Chlapek, Dušan (advisor) ; Kučera, Jan (referee)
This thesis focuses on relational database systems. The main goal of this thesis is to compare two selected database systems - one commercial and one Open Source, which will be compared using criteria, focused on the database administration. The first part provides a theoretical basis concerning the database systems (it will also include a description of the relational principle) and types of licenses under which the software may be issued. The main objective of this section is to create a sufficient theoretical basis for understanding the rest of the paper. The next section explains term database administration and shows the difference between the terms data management and database management. Next follows the analysis of the tasks performed by the database administrator and a description of each task. This part is fundamental for the rest of the thesis, because it will be used as a basis for a comparison. In the next section one Open Source and one commercial relational database system will be chosen. In the part I will also briefly describe the history of each system and their architecture. At the end the two systems are compared. The main asset of this thesis I see in analysis of database administrator tasks and comparison of how different systems help simplify these tasks.
|
|
| |
|
|
Database Version Management for Application Development in Eclipse
Palarczyk, Vít ; Šebek, Michal (referee) ; Burget, Radek (advisor)
This thesis deals with database version control for application development in Eclipse. In the theoretical part, it provides information about the Eclipse environment and its extension modules (plugins) that are an inseparable part of Eclipse. There is also a description of version control systems with a detailed focus on the Subversion system and a description of the JDBC application interface that is used for connecting the database in Java applications. The next part deals with the design of a tool for database version control, which is implemented as a plugin for Eclipse. In this section, there is a description of the implementation and a description of the installation and use of this tool. In the final part, there is a description of the performed tests and their results.
|
|
|
In-Memory Database Management System
Pehal, Petr ; Bartík, Vladimír (referee) ; Rychlý, Marek (advisor)
The focus of this thesis is a proprietary database interface for management tables in memory. At the beginning, there is given a short introduction to the databases. Then the concept of in-memory database systems is presented. Also the main advantages and disadvantages of this solution are discussed. The theoretical introduction is ended by brief overview of existing systems. After that the basic information about energetic management system RIS are presented together with system's in-memory database interface. Further the work aims at the specification and design of required modifications and extensions of the interface. Then the implementation details and tests results are presented. In conclusion the results are summarized and future development is discussed.
|
|
|
Database System Analysis and Implementation
Třetina, Jan ; Ráb, Jaroslav (referee) ; Zendulka, Jaroslav (advisor)
With the increase of demands for the speed and availability of the information technologies, the process of optimization gains more and more importance. Concerning search engine optimization, optimization of operating systems or application optimization (source code), the goal is to gain faster, smaller and more maintainable solution. In my thesis I deal with optimization of database systems, which includes low level of database tuning - physical organization of data and indices, database management system tuning and query optimization. I focused on optimization of Microsoft SQL Servers 2005 in enterprise environment.
|
|
|
Implementation of a test for comparison of database systems' performance
Matějka, Martin ; Chlapek, Dušan (advisor) ; Kaltoun, Jan (referee)
The aim of this thesis is to create a program, which will be able to perform a performance testing of relational database systems supporting query language SQL with an emphasis on open source systems. The test should simulate a real usage of tested database systems. In the introduction is shown the necessity of such program (which is supported by the analysis of existing theses and programs in the second chapter) and the fact, that it is convenient to base the test on the TPC-C as a standard for this type of testing in the proprietary sphere, so all the given requirements could be met. The third chapter gives insights into the history of transactional testing and what were the circumstances of the formation of Transaction Processing Performance Council, which authored the TPC-C specification. The main characteristics of TPC-C are decribed in the following chapter, while the fifth one addresses the implementation, i.e. the creation of the program, which can be used for testing of database systems. The sixth chapter deals with the usage of this program for the comparation of two well known open source database systems in their default configuration - MySQL and PostgreSQL. However, the goal of this testing is to find out whether the created program is fully functional, while the seventh chapter elaborates more on this. The most important outcome of this thesis is a program, which can be used for comparation of real-usage-like performance of (not only) open source relational database systems. This program is an open source, which increases its value since a user has a possibility to find out exactly what is tested and how it is done. Furthermore, it supports the future development of this program. Another outcome of the thesis is the comparation of two open source database systems.
|
guest ::
